﻿USE CORINA_DATA
GO

CREATE TABLE t_device_measure (
    Id INT PRIMARY KEY IDENTITY,
    Name VARCHAR(50),
    Density FLOAT DEFAULT(0),
    Temperature FLOAT DEFAULT(0),
    Humidity FLOAT DEFAULT(0),
    IsOpen BIT DEFAULT(1),
    Tester VARCHAR(50),
    TestTime DATETIME DEFAULT(GETDATE()),
    MessageId INT DEFAULT(0)
)